
Select * from PS_CPR_TEMP0006 --Marca Realizadas por dia

INSERT INTO PS_CPR_TEMP0006 ( PROCESS_INSTANCE 
 , EMPLID 
 , EMPL_RCD 
 , COMPANY 
 , NRO_TARJETA_ETB 
 , KZNPE12_TLE011 
 , DATE1 
 , START_TIME 
 , KZN_DSC_RELOJ 
 , SEQ_NBR 
 , FLAG 
 , DAYOFWK_MON) 
 SELECT A.PROCESS_INSTANCE 
 , A.EMPLID 
 , A.EMPL_RCD 
 , A.COMPANY 
 , A.NRO_TARJETA_ETB 
 , A.KZNPE12_TLE011 
 , A.DATE1 
 , A.START_TIME 
 , A.KZN_DSC_RELOJ 
 , A.SEQ_NBR 
 , A.FLAG 
 , B.DAYOFWK_MON 
  FROM PS_CPR_TEMP0004 A 
  , PS_CPR_TEMP0005 B 
 WHERE A.PROCESS_INSTANCE = B.PROCESS_INSTANCE 
   AND A.DATE1 = B.START_DT 
   AND A.PROCESS_INSTANCE = %ProcessInstance